home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
BMUG Revelations
/
BMUG Revelations.toast
/
Business
/
FileMaker
/
Personal Chk Bk 2.0
/
Check Book 2.0
(
.txt
)
< prev
Wrap
FileMaker Pro Database
|
1989-02-12
|
65KB
|
835 lines
HBAM2001MAY84
Boxboro
Cabinet
England
Eriksons
Insurance
Liquor
Purity
Supreme
Telephone
White
Animals
Beauty
Gifts
Health
Insurance
Payments
Rent/mortgage
Telephone
10203.7
104.23
82.74
85.42
10096.2
82.74
85.42
Foodstuffs
Homeowners
November
Payment
Pocket
Balance
Paycheck
Refund/other
Starting
Deposit
Check
Command-1
Command-n
Deposit
Fifty
Three
Twenty
Seven
Hundred
Seven
3.0F#
4.01I
US Letter A4 Letter
US Legal
International Fanfold
Computer Paper
Directions Layout
els^23456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 12
2/12/89
ACCOUNT NAME
ACCTAMT
ADJUSTEDCENTS
BALANCE
CENTS
CENTS!
CENTS
CENTS!
CENTS!
--ANCE
CENTS
CENTS!
-STEDCENTS
BALANCE
CENTS
CENTS!
CENTS!
-NTS!
CHECK #
CHECKBOOKBALANCE
CHECKSOUTSTANDING
CHECKWARNING
CK AMT
CLEARED
DATE ENTERED
DEPOSIT
DEPOSITSOUTSTANDING
DESCRIPTION
DIFFERENCE
DOLLARS
DOLLARSANDCENTS
HUNDREDS
+ HUNDREDS!
PAYEE
SAYSDEP!
SER.#
SOURCE
STATEMENTBALANCE
SUM CREDITS
SUM DEBIT
SUMACCTAMT
SUMBALANCE
SUMDEP
TENS!
. THENUMBER
2 THOUSANDS
THOUSANDS!
DateB
Date EnteredB
PayeeB
Ck AmtB
E TheNumberF
DepositB
Account NameB
Animals
Auto Payments
Auto Service
Bank Charges
Beauty and Health
Clothing
Dentist
Gifts
Household
Insurance
Medical
Other
Rent/Mortgage
Telephone
Travel
AcctAmtB
CHECKBOOK FOR P.
SumAcctAmtB
sum (AcctAmt)F
DifferenceB
E3if(Ck Amt - SumAcctAmt = 0," ",Ck Amt - SumAcctAmt)F
Check #B
DescriptionB
Ser.#B
A Sum DebitB
Sum CreditsB
BalanceB
(SumDep - Ck Amt)F
SumBalanceB
SourceB
A,Borrowed
Interest
Paycheck
Refund/Other
SumDepB
sum (Deposit)F
SaysDep!B
if (Deposit > 0,"DEPOSIT","")F
DEPOSIT'
CheckWarningB
E`if (Ck Amt > 0,"This is a Check! Type Command-N for a new deposit or Command-1 for a check.","")
'KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.'
ClearedB
StatementBalanceB
ChecksOutstandingB
DepositsOutstandingB
CheckbookBalanceB
E:StatementBalance + DepositsOutstanding - ChecksOutstandingF
DollarsB
CentsB
AdjustedCentsB
EPif(length(right(Cents,length(cents)-position(Cents,".",1)))=1,cents & "0",cents)F/&
TensB
right(dollars,2)F
HundredsB
(right(Dollars,3)-Tens)/100F
,A ThousandsB
E@if(length(dollars)
4,middle(Dollars,1,(length(Dollars)-3)),"")F,&
Cents!B
1 to 1000 lookup
Tens!B
1 to 1000 lookup
/A Hundreds!B
1 to 1000 lookup
Thousands!B
DollarsandCentsB
proper(if(Thousands
1,thousands! & " Thousand " ,"" ) & if(Hundreds
1,hundreds! & " hundred" & " " , "") & if(Tens
1,(tens! & " "),"") & if(cents!
1," and " & AdjustedCents & " /100",""))F
Thousand ('
hundred('
and &
/100('
2A TheNumberB
E)TextToNum (Dollars & "." & AdjustedCents)F
Command-N for New Deposit
Command-1 for New Check
Deposit Ticket
Source
Amount
You Name
Your Address
City, ST zip
Total
Acct #
1234 5678
====>
Balance
Command-N for New Deposit
Command-1 for New Check
Deposit Ticket
Source
Amount
You Name
Your Address
City, ST zip
Total
Acct #
1234 5678
====>
Balance
General Ledger
Check #
Payee
Balance Forward
General Ledger
Check #
Payee
Balance Forward
Check Entry
Command-N for a blank check.
Command-2 to do a deposit.
Command-Q to quit.
Check Entry
Command-N for a blank check.
Command-2 to do a deposit.
Command-Q to quit.
ORDER OF:
Total Deposits ==>
Total Checks
Click Here
Click Here
Click Here
Click Here t.
Click Here
====>
Balance
for Balance
for Balance
Balance
for Balance
blank check.
Command-2 to do a deposit.
Command-Q to quit.
Dollars
What For:
How Much:
Description:
Much:
Total Deposits ==>
Total Checks
Click Here
====>
Your Name Here
PAY TO THE
ORDER OF:
Clear Checks
*Type Y in Cleared box if check has cleared
Clear Checks
*Type Y in Cleared box if check has cleared
*Type Y in Cleared box if check has cleared
/Type Command-4 when thru to balance checbook.
Check #
Payee
Cleared?
Clear Checks
*Type Y in Cleared box if check has cleared
/Type Command-4 when thru to balance checbook.
Check #
Payee
Cleared?
Balance CheckBook
-Type the balance shown on your statement here
Balance shown on
statement
to the boxes
into the boxes
Deposits Outstanding
Type these numbers
into the boxes
to their left
Checks Outstanding
If a box is empty, type a zero
Deposits Outstanding
Type these numbers
into the boxes
to their left
Directions:ns:
Checks Outstanding
CheckbookBalance
should be:
Directions:
KNote: You should have the font Helvetica installed in your system for these
9layouts to look right, let me know if you have a problem!
Setting Up Your Checkbook:
HYou may first want to take a look at the checkbook with the entries I've
E put in just to get an idea of how things work. When you've got the
I forget to enter the charges listed on your statement before you go to
clear!
FMake sure you check off all returned items, including bank charges and
J interest paid into your account before you go to balance the checkbook.
To Balance The CheckBook:
deposit slip.
GRecord Interest income and other transfers into your account using the
deposit layout.
To Post Returned Items:
GWhen you recieve your statement, check off all returned items by typing
H Command-3 and typing a Y in the cleared box for items returned, don't
To Record a Check or Charges:
@To cut a check type Command-1, then Command -N for a blank check
DRecord bank charges, checking fees and other debits using the check
layout.
To Record a Deposit or Interest:
?To record a deposit type Command-2, then Command-N for a blank
> Summary of Expenditures for your review, you may also type
/ Command-3 to view a summary of all deposits.
$So, THAT'S where all the money goes!
HI have input the checks already so you can see how it works, you'll want
Lto Delete Multiple before trying another Input, check the totals to be sure!s as they dawn on me or when you give me input
OIf your balance is off, try looking for the amount you're off by in case you
F missed an item when clearing the checks and deposits, if not, then
double check your data entry!
)To Summarize Expense and Income Accounts:
GBecause of limitations of the program you must open the Accounts Input atement in the top
EWhen you've cleared all items returned, type Comand-4 to balance the
I checkbook. Type in the balance forward from your statement in the top
F box, then enter the amounts shown as outstanding in the appropriate
boxes.
EIf all goes well, your checkbook balance should match your statement
balance.then
J Find criteria and do the Find prior to opening the Accounts Input File.
GWhen you open the input file, simply press Command-1 to start the input
J script, when asked double click on the CheckBook 2.0 file then click OK
L on the input screen. The script will automatically display a preview of e information you will probably want to find
K File, located elsewhere in this folder, and input records from the check
I book. Before importing the information you will probably want to find
K either all transactions (for a yearly or to date summary) or only those
L for a given period. Use the View All Transactions layout to specify the
What Else?:
EYour comments and suggestions are greatly appreciated, I will try and
Dimplement improvements as they dawn on me or when you give me input
Password:.
$So, THAT'S where all the money goes!
Password:<
$So, THAT'S where all the money goes!
Password:
ESimply drop me a note via E-mail. I run a small woodworking business
Eon a much more sophisticated version of this very same checkbook that
Eallows me to disburse across virtually unlimited accounts. I've been
Bdeveloping my own checkbook for over 2 years, if you're interested
Clet me know! Kudo's to Nashoba Systems for a fine program! Let's
hope that Claris keeps it up!
Messages should be addressed to:
Mark White
459 Liberty Square Rd.
(508)263-4322
Boxboro, MA 01719
GE: MRWhite
CompuServe: 73170,3150
Clet me know! Kudo's to Nashoba Systems for a fine program! Let's
Directions:
KNote: You should have the font Helvetica installed in your system for these
9layouts to look right, let me know if you have a problem!
Setting Up Your Checkbook:
HYou may first want to take a look at the checkbook with the entries I've
uServe: 73170,3150
J number, precede the entry with a "-" (minus sign). Make sure you post
: your starting balance by typing a "Y" in the clear box!
To Record a Check or Charges:
@To cut a check type Command-1, then Command -N for a blank check
DRecord bank charges, checking fees and other debits using the check
layout.
To Record a Deposit or Interest:
?To record a deposit type Command-2, then Command-N for a blank
deposit slip.
GRecord Interest income and other transfers into your account using the
deposit layout.
To Post Returned Items:
ayout and
GWhen you recieve your statement, check off all returned items by typing
H Command-3 and typing a Y in the cleared box for items returned, don't
I forget to enter the charges listed on your statement before you go to
clear!
FMake sure you check off all returned items, including bank charges and
What Else?:
J interest paid into your account before you go to balance the checkbook.
To Balance The CheckBook:
EWhen you've cleared all items returned, type Comand-4 to balance the
I checkbook. Type in the balance forward from your statement in the top
F box, then enter the amounts shown as outstanding in the appropriate
To Post Returned Items:
GWhen you recieve your statement, check off all returned items by typing
H Command-3 and typing a Y in the cleared box for items returned, don't
I forget to enter the charges listed on your statement before you go to
clear!
boxes.
EIf all goes well, your checkbook balance should match your statement
balance.
OIf your balance is off, try looking for the amount you're off by in case you
F missed an item when clearing the checks and deposits, if not, then
double check your data entry!
our statement in the top
)To Summarize Expense and Income Accounts:
GBecause of limitations of the program you must open the Accounts Input
K File, located elsewhere in this folder, and input records from the check
I book. Before importing the information you will probably want to find
double check your data entry!
checks and deposits, if not, then
Command-n
K either all transactions (for a yearly or to date summary) or only those
L for a given period. Use the View All Transactions layout to specify the
J Find criteria and do the Find prior to opening the Accounts Input File.
GWhen you open the input file, simply press Command-1 to start the input
enter the amounts shown as outstanding in the appropriate
J script, when asked double click on the CheckBook 2.0 file then click OK
L on the input screen. The script will automatically display a preview of
> Summary of Expenditures for your review, you may also type
/ Command-3 to view a summary of all deposits.
$So, THAT'S where all the money goes!
HI have input the checks already so you can see how it works, you'll want
Lto Delete Multiple before trying another Input, check the totals to be sure!
What Else?:
EYour comments and suggestions are greatly appreciated, I will try and
Dimplement improvements as they dawn on me or when you give me input
ESimply drop me a note via E-mail. I run a small woodworking business
Eon a much more sophisticated version of this very same checkbook that
Eallows me to disburse across virtually unlimited accounts. I've been
Bdeveloping my own checkbook for over 2 years, if you're interested
Clet me know! Kudo's to Nashoba Systems for a fine program! Let's
hope that Claris keeps it up!
Messages should be addressed to:
Mark White
459 Liberty Square Rd.
(508)263-4322
Boxboro, MA 01719
GE: MRWhite
CompuServe: 73170,3150
Clet me know! Kudo's to Nashoba Systems for a fine program! Let's
hope that Claris keeps it up!
Messages should be addressed to:
Mark White
459 Liberty Square Rd.
Boxboro, MA 01719
GE: MRWhite
CompuServe: 73170,3150
CheckBook Set-Up
LBefore you can use your checkbook you must enter your starting balance here.
QFirst, if the checkbook is not yet empty, delete all records, then type Command-7
Qto return to this screen, type Command-N for a new record, hit the Tab key, enter
Syour info (be sure to enter a "Y" in the cleared box to post your balance) and you
Starting Balance
Cleared
CheckBook Set-Up
LBefore you can use your checkbook you must enter your starting balance here.
QFirst, if the checkbook is not yet empty, delete all records, then type Command-7
Qto return to this screen, type Command-N for a new record, hit the Tab key, enter
Syour info (be sure to enter a "Y" in the cleared box to post your balance) and you
1may then begin to enter your checks and deposits.
your balance) and you
Check Entry
Cleared
Check Entry
Your Name Here
Dollars
To The Order Of
Description
Check Amount
Total Deposits ==>
Total Checks
====>
Balance
Check Entry
Your Name Here
Dollars
To The Order Of
Description
Check Amount
Total Deposits ==>
Total Checks
====>
Balance
Check Entry
Your Name Here
PAY TO THE
ORDER OF:
What For:
How Much:
Description:
Total Deposits ==>
Command-N for a blank check.
Total Checks
Command-2 to do a deposit.
Click Here
====>
Balance
Command-Q to quit.
for Balance
Check Entry
Your Name Here
PAY TO THE
ORDER OF:
What For:
How Much:
Description:
Total Deposits ==>
Command-N for a blank check.
Total Checks
Command-2 to do a deposit.
Click Here
====>
Balance
Command-Q to quit.
for Balance
12/3/88E
2500U
2500Y
Starting BalanceZ
2500[
DEPOSIT]
12/3/88B
12/3/88C
EriksonsD
55.5F
AnimalsH
55.5I
55.5J
dog foodR
-55.555j
fifty fiveq
Fifty Five r
12/3/88B
12/3/88C
My BankD
Auto PaymentsH
car paymentR
-250\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.g
fiftyo
-85.42Co.
F InsuranceH
homeownersR
-535\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.]
thirty fiveo
fiveq
Five Hundred Thirty Five r
12/3/88B
12/3/88C
Ye Olde Liquor CabinetD
FoodH
beer and wineR
-22\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.]
twenty twoq
Twenty Two d 74 /100r
82.74
12/3/88B
12/3/88C
CashD
CashH
pocket $R
-1000k
12/11/88B
12/11/88C
American ExpressD
107.5F
Gifts
ClothingH
102.7
107.5J
1234R
-107.5\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.]
fiftyn
seveno
One Hundred Seven And 50 /100
107.5
12/11/88B
1/2/89C
Purity SupremeD
104.23F
FoodH
104.23I
104.23J
1235R
-104.23\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.g
twenty threen
fouro
One Hundred Four And 23 /100r
104.23
1/21/89B
1/21/89C
andyD
1000F
GiftsH
1000I
1000J
hahaR
-1000\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.g
1000j
One Thousand r
Write A Check
parrott
Do A Deposit
Clear Checks
Balance Checkbook
View All Transactions
Directions for Use
Set-Up
Thousand
Thousand
Deposit
Thousand
end ()I
FV (,,)J
if (,,)K
int ()L
left (,)M length ()N
lower ()O
max ()P
middle (,,)Q
min ()R
mod (,)S
month ()T
NPV (,)U
NumToText ()V
pmt (,,)W
position (,,)X proper ()er () ()B
> idea then Delete Multiple and just follow the instructions.
FWhen setting up your checkbook, begin by going to the SetUp layout and
J entering your starting balance. If your starting balance is a negative
J number, precede the entry with a "-" (minus sign). Make sure you post
: your starting balance by typing a "Y" in the clear box!
CHECK #
2/12/89R
2/89C
whoeverD
99111.01J
99111.01O
12U -99111.01\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.g
99111h
eleveno
ninety nineq4Ninety Nine Thousand One Hundred Eleven And 01 /100r
99111.01111111
American
Cabinet
England
Eriksons
Express
Insurance
Liquor
Purity
Supreme
Telephone
Animals
Beauty
Gifts
Health
Insurance
Payments
Rent/mortgage
Telephone
104.23
107.5
82.74
85.42
1000.01
0096.2
82.74
85.42
Foodstuffs
Homeowners
November
Payment
Pocket
Balance
Paycheck
Refund/other
Starting
Deposit
Check
Command-1
Command-n
Fifty
Three
Twenty
Seven
Hundred
Seven
Command-n
Deposit
PV (,,)Z
replace (,,,)[ right (,)\ round (,)]
sign ()^
stdev ()_
sum ()`
TextToDate ()a
TextToNum ()b
today c
trim ()d
upper ()e
year ()
1 to 1000 lookup
DollarsandCentsB
Animals
Beauty
Clothing
Gifts
Health
Insurance
Payments
Rent/mortgage
Telephone
Foodstuffs
Homeowners
November
Payment
Pocket
Fifty
Forty
Seventy
Three
Twenty
Eighty
Fifty
Seven
Thirty
Twenty
Eighty
Fifty
E put in just to get an idea of how things work. When you've got the
> idea then Delete Multiple and just follow the instructions.
FWhen setting up your checkbook, begin by going to the SetUp layout and
J entering your starting balance. If your starting balance is a negative
Rent/MortgageH
Nov. Pmnt. ( I Wish!)R
-2\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.]
\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.]
One Hundred r
12/3/88B
12/3/88E
Paycheck
Refund/OtherZ
DEPOSIT
DEPOSIT]
12/4/88B
12/3/88C
My Bank
12/3/88B
12/3/88C
New England TelephoneD
82.74F TelephoneH
82.74I
82.74J
November billR
-82.74\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.^
1250_
1186.97`
63.0299999999999999g
seventy fourn
eighty twoq
Eighty Two And 74 /100r
82.74
12/3/88B
12/3/88C
CashD
CashH
pocket $R
Hundred
Seven
Thirty
Thousand
Twenty
0m forty twon
eighty fiveq
Eighty Five And 42 /100r
85.42
12/3/88B
12/3/88C
My Insurance Co.
\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.]
Two Hundred Fifty r
12/3/88B
12/3/88C
Purity SupremeD
85.42F
Beauty and HealthH
23.42I
85.42J
foodstuffs
misc.R
-85.42
\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.]
fiftyn
fifty fiveq
Fifty Five And 50 /100r
12/3/88B
12/3/88C
My BankD
Auto PaymentsH
car paymentR
-250\KThis is a Check! Type Command-N for a new deposit or Command-1 for a check.]
fiftyo
CheckbookBalance
should be:
-Type the balance shown on your statement here
Balance shown on
statement
Balance CheckBook
-Type the balance shown on your statement here
Balance shown on
statement
Checks Outstanding
If a box is empty, type a zero
CheckbookBalance
should be:
1may then begin to enter your checks and deposits.
TIf, sadly, your starting balance is a negative number, precede it with a minus sign.
ORDER OF:
Dollars
What For:
How Much:
Description:
Check Entry
Command-N for a blank check.
Command-2 to do a deposit.
Command-Q to quit.
Check Entry
Command-N for a blank check.
Command-2 to do a deposit.
Command-Q to quit.
Your Name Here
PAY TO THE
TIf, sadly, your starting balance is a negative number, precede it with a minus sign.
Starting Balance
Cleared